﻿

create PROCEDURE [dbo].[proc_ConsumableMonth_Count]
(
	@f_id INT	
)
	
AS
IF @f_id=0
  SELECT COUNT(*) FROM ConsumableMonth
  ELSE
  	SELECT COUNT(*) FROM ConsumableMonth WHERE F_id=@f_id